[dbo].[BAEImisZipCodeGetUserCounty]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisZipCodeGetUserCounty

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@Zip	varchar(5)	5

SQL Script

create procedure [dbo].[BAEImisZipCodeGetUserCounty] @Zip varchar(5) as
SELECT    CITY, COUNTY, STATE
    FROM        Zip_Code
    WHERE    ZIP = @Zip;

GO

Uses

[dbo].[Zip_Code]
dbo